SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweUsuarios
AS
SELECT idUsuario AS id, Nombre, Email, Clave, Usuario, NTUser, Activo, esJefe, idReparticion, Nivel, Modo
FROM  dbo.tb_Usuarios
GO
GRANT SELECT ON  [dbo].[vweUsuarios] TO [AdministracionSagenet]
GRANT INSERT ON  [dbo].[vweUsuarios] TO [AdministracionSagenet]
GRANT DELETE ON  [dbo].[vweUsuarios] TO [AdministracionSagenet]
GRANT UPDATE ON  [dbo].[vweUsuarios] TO [AdministracionSagenet]
GRANT SELECT ON  [dbo].[vweUsuarios] TO [PersonalDocenteDireccion]
GRANT SELECT ON  [dbo].[vweUsuarios] TO [SoloVer]
GO
